SQL query generator wizard


The SQL Query generator is a strong feature and will help you to create SQL queries fast, efficient and with ease, you can test the query to see if it is in working order and check if the data is existing in the database.

Select a datasource, then select a database and finally select the fields you want to have in the query, then click on Generate Sql.

You can add extra information to the query,if you want to display a field that contains a certain value, for example if orderid equals 10, you would set the value box to 10, click on add to statement and there it is.

Here is the result of the demo query, the database contains data, the query is working, we can use this query in our web project!